-- Removes line breaks DECLARE teststring VARCHAR2(32767) := ' This is the value that I chose'; BEGIN DBMS_OUTPUT.PUT_LINE(teststring); DBMS_OUTPUT.PUT_LINE(replace(replace(teststring, chr(13), ''), chr(10), ' ')); END;